concurrent transaction meaning in English
并行事务
并行细目数据
Examples
- Exclusive locks prevent access to a resource by concurrent transactions
排他锁( x锁)可以防止并发事务对资源进行访问。 - Shared locks allow concurrent transactions to read select a resource under pessimistic concurrency control
共享锁( s锁)允许并发事务在封闭式并发控制(请参阅 - Conversely , a query holding a sch - s lock blocks a concurrent transaction that attempts to acquire a sch - m lock
相反,持有sch - s锁的查询将阻塞尝试获取sch - m锁的并发事务。 - When one transaction holds a lock on an item , no concurrent transaction can read and / or modify this item
当一个事务对一个数据拥有了锁,那么其他并发事务则无法对它进行读或者写。 - Because of this , queries are blocked when a concurrent transaction holds a sch - m schema modification lock on the table
因此,当并发事务持有表的sch - m (架构修改)锁时,将阻塞查询。